Table

Entity Definition

Logical Name : Table
Physical Name : LO_TB

A place at which one or more Customers sit to eat food purchased in a FoodServiceTransaction.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TableID (PK) A unique retailer assigned identifier for a particular table, at which Customers sit to eat food purchased in a FoodServiceTransaction. ID_TB Identity integer
LocationID (FK) A unique system assigned identifier for the SellingLocation. ID_LCN Identity integer SellingLocation(LO_LCN_SL)

Relationships

Parent Entity Verb Phrase Child Entity
SellingLocation contains Table
Table was location for FoodServiceTransaction
Table was location for FoodServiceLineItem

Logical Views containing Table

Logical View
Logical 02360 - Retail Transaction - Food Service View